﻿CREATE TABLE [dbo].[NHIEMVU] (
    [Id]            INT              NOT NULL,
    [ChuDe]         NCHAR (100)      NOT NULL,
    [NgayBatDau]    DATETIME         NOT NULL,
    [NgayHetHan]    DATETIME         NOT NULL,
    [TinhTrang]     NCHAR (100)      NOT NULL,
    [DoUuTien]      NCHAR (100)      NOT NULL,
    [TiLeHoanThanh] FLOAT            NOT NULL,
    [LoaiNhiemVu]   NCHAR (100)      NOT NULL,
    [CoNhacViec]    BIT              NOT NULL,
    [IdLienQuan1]   UNIQUEIDENTIFIER NULL,
    [IdLienQuan2]   UNIQUEIDENTIFIER NULL,
    [DienGiai]      NVARCHAR (MAX)   NULL,
    [IdDoiTuong]    UNIQUEIDENTIFIER NOT NULL
);



